SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458478 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458478 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383882,102736,764373,292502,336708,889987,947920,800390,421722,840880,422406,191397,854616,334605,842644,197619,494019,396124,511607,724665,675140,643977,4169,326757,395346,605242,517,350952,672172,557847,390408,517753,688092,325511,869236,913657,219660,420607,242329,226880,794300,113599,225845,543766,442783,358606,745615,988180,100030,685775,718219,993756,710854,552577,960870,647244,763343,506906,43478,117785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]