SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346051 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346051 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554405,461476,590958,416758,350477,908414,557461,638755,180674,184026,369436,721272,154941,847741,728301,523268,431010,610146,1032799,107666,23719,1034375,31313,698265,905889,640825,784839,821763,214941,14611,927439,434361,732891,894144,847231,90876,367301,301326,153019,541137,573526,1020923,676620,607694,502577,412220,124805,204317,1028147,377345,661476,668199,4710,455028,764073,57598,743732,191836,656540,209195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001113s ]