SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003703s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106308 LIMIT 1 [ RunTime:0.002129s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106308 [ RunTime:0.002629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591043,110996,511453,644676,313095,758835,593428,778001,680240,874756,517552,161016,399065,724241,10022,983305,1012109,729434,733947,781682,605017,522282,917530,713525,101309,527394,754722,651903,295609,125316,484312,139603,982973,531331,395784,78282,953227,616208,784536,85060,568946,549390,159149,186701,626287,145589,745840,621128,830000,820155,618775,964833,87454,987320,196922,47484,878004,424153,180556,800360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.029250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002031s ]