SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005223 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005223 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269403,982126,436341,845894,509027,1028273,949336,805550,467290,895089,928923,594103,950011,418920,853840,851321,473972,647225,844829,496861,142054,748199,950250,893800,679783,585373,572283,468189,704713,983193,979202,688051,9818,949493,401220,56242,511386,17443,414861,18971,1009136,709810,387188,453307,489246,482441,33020,945179,152718,48224,90964,860368,211252,462528,129351,467893,270396,639742,525304,564336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]