SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54101 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54101 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41287,147523,919415,532576,171529,629637,1046049,677675,544661,253087,12358,903250,911655,302082,1038513,598965,509891,733231,141023,44846,665957,17894,572761,605576,546943,959411,67137,610711,662721,1024673,52180,461283,63367,164290,934176,427864,403400,1002297,62191,796504,604339,668641,83276,178396,591286,1039275,997392,926115,404560,348700,557856,1016087,939115,895263,133076,826592,1018110,390329,442722,22550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]