SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510881 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510881 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316801,909807,284055,263474,21153,78978,570787,920211,393997,668044,526835,625403,217165,714030,879597,57228,735272,804723,769757,436785,334742,586347,114606,561702,1009424,198621,996164,870390,593801,171202,115478,246319,328348,1018187,755416,80858,356924,246628,913832,803371,809102,45022,433128,23302,394241,464390,199790,453380,731007,471957,337808,404214,261211,583725,431517,821352,1027407,1046562,69335,991227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]