SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267128 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267128 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763922,835143,494452,550437,418907,932751,103581,640651,1008317,620133,227432,956548,4074,5799,1048114,356861,472863,1029149,469184,449200,897528,462026,272126,449822,636752,41170,948581,881523,459610,16906,727662,517057,727542,662821,646274,4125,744775,606024,780954,441933,937527,480578,530598,935294,980839,763562,92816,70268,749880,165032,35689,736427,513394,1019252,483188,1007010,226155,994501,785921,53413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]