SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458399 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458399 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31987,596548,985870,878803,97743,353300,454923,397541,977860,694972,213485,659873,128076,235904,4323,604572,60684,105020,991437,981428,105642,60658,215985,167592,607215,216584,522940,222535,814862,501347,709792,782163,297727,471989,742182,621071,317074,130393,265883,875036,391172,1037744,849010,669389,624873,910616,907873,999895,1030156,59229,430764,235867,990929,650695,94156,947102,641905,285217,1042873,198930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]