SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411143 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411143 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742795,506691,372155,332281,540079,765184,823667,305404,93304,508128,131211,371080,824357,123700,125307,255556,151432,735913,634936,1015776,180739,333723,758516,807105,627664,274674,323957,130576,782715,129565,316958,452255,407256,114716,335784,1048433,1021999,62510,720611,921872,176810,334455,118511,239370,725210,890355,702579,448256,755107,251596,568748,987848,168074,173429,428679,946181,112000,104466,567221,196041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]