SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100612 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100612 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787214,101532,758987,130742,512263,934539,831270,228401,1019712,715197,373155,161163,771010,832500,1037755,900701,347962,338631,697852,498608,919129,679472,419752,1027129,1013088,660391,997362,820124,538015,744746,425191,784492,854022,392353,165339,17595,948745,840612,446883,933345,93181,756168,240315,283350,164700,467342,485630,85770,263671,143104,93168,641893,270795,152710,1037506,197213,856692,330857,613994,793979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]