SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490749 LIMIT 1 [ RunTime:0.001324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490749 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117619,923050,671498,485063,312547,510258,654235,637046,816401,100650,1008978,382114,976814,783827,948891,467758,619047,279879,951703,157592,469905,385117,726238,391660,934581,1046611,440139,808890,145056,267162,108977,166070,22244,241491,925589,734029,191581,25962,212843,729133,1048073,333573,1026177,704683,381150,940443,765349,70237,293087,1031218,698102,249553,136972,104408,430618,834368,785066,655595,197114,695944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]