SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398513 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398513 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142873,952175,863212,206797,428038,582410,773463,18553,890703,727768,240719,286948,459088,111947,854708,684851,119066,819939,256507,507354,501473,944248,457411,784198,28407,903657,898301,604111,78415,285465,331636,474749,560733,614816,684644,509492,167990,439973,731136,146931,586628,39265,719506,172195,629052,72672,114577,844564,841186,868544,557045,568006,611836,596546,294968,181830,425740,252446,223974,437612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001208s ]