SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683272 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683272 [ RunTime:0.004155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484814,198294,83476,219680,334757,501830,215391,222696,734963,710932,300882,28191,104648,216939,479672,68012,433329,190698,1034912,57178,877773,808560,411461,101276,835676,127187,141327,261475,108130,949793,62216,489828,620669,63191,336976,560903,232096,668600,298677,81028,762177,817780,256260,1010519,618241,680223,18436,1013362,856344,91377,328069,276479,480657,221268,872943,1020694,464169,850211,920337,828235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004432s ]