SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485196 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485196 [ RunTime:0.002745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547642,33919,59980,383902,925847,430778,832075,214414,414483,578321,667264,300681,241120,802448,484100,492672,920886,76179,181437,854659,431313,78104,1008153,943000,817056,601927,252687,710962,287887,740753,330086,907277,385515,342170,342127,1003867,939262,162413,156671,139033,213890,631506,1032886,68013,853071,798106,755180,927273,543554,64188,913700,212600,1037549,825758,841519,750659,1021794,1007296,557888,71405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]