SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267661 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267661 [ RunTime:0.002826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951123,819822,639185,666648,837606,488386,748644,148669,914961,590384,391386,547418,951873,406903,136661,100578,802881,770552,1019992,684500,98237,980537,368172,64527,437972,780979,242880,72845,621084,230993,98937,229958,753226,829698,203952,361163,973593,163382,503556,144130,771230,23229,12628,268451,719255,583427,245200,36867,464153,772296,344565,242160,831938,633496,683773,240098,965417,762448,10651,553726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267661 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267661 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]