SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668414 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668414 [ RunTime:0.002280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048387,514061,881250,557651,20165,506194,249664,1007841,890203,163923,336582,355043,434415,365850,884571,472280,289381,858611,441412,496329,267646,203397,361979,565170,853905,615466,565712,387364,791349,30131,860161,745832,941600,767885,201389,1031293,414818,953399,276916,234959,116849,378548,592220,787253,376139,967040,114034,382735,225906,472471,394594,325850,373146,34645,861359,113869,422894,979801,448401,117246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]