SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456577 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456577 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517180,776436,28849,253662,1034750,650813,92412,74533,263537,44365,432341,531601,576041,980083,763158,155273,136348,767516,353837,105104,566146,631764,255418,671854,230320,915291,562655,768033,835209,1032043,461279,836490,152988,613236,563389,220034,347725,892706,375589,114898,843524,182350,738500,911835,371672,75522,670011,58368,109934,443402,847311,659051,812359,408465,568773,821529,564390,637924,431079,1020018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456577 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456577 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]