SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450880 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450880 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803981,692284,608669,575904,672635,717114,451604,16312,583588,839423,795942,377925,363319,436141,826111,754507,60358,915112,621854,221751,1026389,892919,456585,588622,474928,814475,987447,103934,583111,495718,867993,53959,729956,584800,587166,79024,154966,437318,873491,477843,943987,134219,239055,680397,1043713,1015285,234680,311409,371460,55641,1018639,1043959,22205,511714,780201,384510,657015,811634,892565,234361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]