SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401711 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401711 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881650,986416,277618,439600,1008535,219415,556459,821294,263933,589794,867143,940579,12097,592791,641538,808481,610048,256998,8357,722619,114245,900029,878859,952197,616413,621739,456063,698344,386204,155833,665532,148023,656346,446078,618842,549425,937577,992247,261038,853140,80738,519589,440920,765368,398653,748733,980048,113973,223046,889787,576213,910037,495501,784558,513806,605965,575379,889915,807380,671289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000379s ]