SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 657316 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 657316 [ RunTime:0.003121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785911,173749,479506,225634,208886,444349,792074,200418,452022,213579,460766,778757,574805,830161,200393,473469,990932,381907,1002173,859622,1005473,580991,478061,75309,453284,606543,409263,255886,402396,739145,214405,633688,996253,867807,147098,591466,569748,687704,823109,849745,183228,183318,327457,312341,658579,199843,138301,864353,509570,1046564,47106,165958,720593,32885,482100,497384,633386,528085,120738,96799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 657316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 657316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]