SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104170 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104170 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26350,115547,710044,248215,846321,755209,636094,198516,675740,606164,1046423,575993,478205,819733,1011245,25596,25981,109676,1000816,561577,628430,791809,100040,427808,433818,58636,796447,280891,305319,692517,797996,191963,16950,518351,362684,620461,318038,269834,941775,600407,449318,148132,71607,650773,963276,902603,256918,308598,387649,67346,1047691,834927,773158,316370,276454,1034119,759621,1043863,167748,902038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]