SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006760 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006760 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543396,44290,148662,201767,681080,430420,999535,585975,799561,270590,855784,482417,496518,296861,646220,178503,281849,851199,269014,507399,808434,908883,906449,55903,263869,880297,67716,671112,538227,836086,216173,1020647,456995,451020,734509,28248,437500,948392,660662,624328,205173,1027353,191142,862593,786283,868670,441746,62228,862362,242162,741151,975431,715663,508255,603786,976662,318446,739757,452130,211949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]