SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457539 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457539 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979630,328376,317596,106618,388742,486878,480118,287869,173598,41734,873915,619559,799259,1003932,399242,626787,188316,69996,33138,813417,183351,619092,942843,366148,70084,296222,355927,618913,274999,922340,385160,135324,924193,163132,751368,256648,844705,508836,1020480,846726,466865,1011554,155857,368660,632371,373407,37044,954244,72000,69759,444460,184127,556832,10232,265926,606442,446317,909631,324108,831495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002927s ]