SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419756 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419756 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475136,657712,964817,272005,792642,476317,370258,44180,845640,971085,30371,425179,718471,514663,641125,201534,959237,290109,992899,91668,741561,370474,179931,138912,156730,700050,282365,764867,770763,278390,730654,285307,706050,696232,387729,953527,843091,824780,783754,114356,386354,100624,422390,639237,331097,892452,85688,882413,951133,945782,54232,545784,881372,839494,457559,449373,600523,379688,601036,728771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419756 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419756 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]