SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480540 LIMIT 1 [ RunTime:0.000987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480540 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686135,174619,870825,221678,859926,835033,739662,841882,60851,323687,952524,1003740,115833,695758,749238,791871,110890,409699,372437,296959,310173,537914,199032,1047453,838672,800246,794611,938920,266481,101460,557022,220947,659243,850909,120812,796588,506975,235460,1041435,542829,1026185,331057,1014367,728128,278265,548928,103986,344033,726173,342253,916061,199425,199504,457267,388331,821924,742070,897314,872635,353261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]