SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295023 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295023 [ RunTime:0.004694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294902,671020,657813,389322,672458,857199,322813,733093,968542,296370,1043062,861734,223372,386023,774071,255285,306653,770166,202968,844368,727065,791475,957364,1048360,864320,622942,54064,461915,104745,723646,213657,331576,945680,946744,705858,867381,643847,600677,180956,673220,52993,514693,1031579,547098,881646,1043640,682498,41701,4902,614689,76080,608256,970796,791403,13732,875271,773452,510720,172358,294585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]