SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042158 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042158 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261182,857182,97398,248180,663838,743675,127954,1047744,1036874,454559,459994,844478,701792,218954,482885,567433,677714,1018819,926586,39260,166016,230872,345436,969087,317433,730052,505992,213338,132642,645385,330582,1043796,489729,566413,747146,122136,83546,628030,947045,206333,795545,166555,325243,726413,11412,49965,521789,597181,296432,952520,114641,517353,304338,615758,935276,732149,308326,377855,864753,727816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]