SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580118 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580118 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341784,659513,617345,181184,1044396,424318,723851,320683,58718,168257,448018,560187,955961,661630,235439,125783,467660,317147,1004054,989645,851559,383214,296640,667825,295996,704308,103904,899384,1019319,907705,634248,783628,108620,520551,610260,446297,402903,711865,185234,664362,652462,814064,912053,249886,284942,1042838,39173,1008661,398193,443041,562105,590827,733284,299448,913888,996906,941808,147677,498224,942325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]