SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000813 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000813 [ RunTime:0.003274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389064,20872,810460,146270,156336,994872,645888,275165,130591,490976,270439,782951,952018,973237,216444,410648,297261,726804,441017,982808,645443,257638,1030389,792659,624033,946243,758208,617896,802019,100795,170398,390102,187942,1029858,173518,812688,927135,199206,266112,395471,419578,778351,268526,640155,102260,92565,535812,793079,896137,1040926,684585,301715,637300,748372,806158,435405,425137,626524,597646,418196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]