SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028001 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028001 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17272,168229,503439,923587,309550,1014782,47882,705814,129566,647619,148404,743730,652373,384816,441812,658372,777198,802120,841379,17235,602507,157928,710551,297571,277110,295864,159888,91426,565227,70607,443797,853400,566121,809442,442486,750252,548923,132454,34130,237525,173577,612919,611680,601803,178909,117481,813602,73025,571859,536634,267774,486093,645961,446284,566282,622281,97207,968433,566865,463362) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001209s ]