SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172311 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172311 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411273,7858,433575,474429,273488,112490,162105,344848,713991,137478,144954,736565,790332,63831,538299,163702,409040,191390,441675,16055,292810,822711,805156,342572,252731,231844,466957,815755,355206,278942,365676,735875,813111,137215,236821,687058,513182,87834,505260,499581,1013296,614408,91561,630475,867767,568979,461503,657433,363516,543874,146408,170855,182754,989913,921351,434560,856683,479585,685603,423973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]