SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806300 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806300 [ RunTime:0.001383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209918,894154,369573,64913,269137,276427,721883,449216,543337,213939,209600,967864,595387,417408,654411,391685,371131,14562,665239,792183,35893,623847,260846,128516,1037958,64566,446556,13626,636027,610925,53289,113535,173243,64768,103840,26639,973939,562726,379223,301997,733263,811187,991379,977414,493543,686425,421291,218336,802940,847543,352052,680890,661294,735724,863112,620191,49377,196712,249156,90319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]