SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509205 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509205 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454253,981808,302849,192406,34499,1027479,447094,405527,542197,625671,684982,918609,456661,426678,268862,613625,93484,857784,883474,834108,250249,617352,764518,766901,945215,366060,367992,426911,697563,444040,1008138,229078,728310,789651,700420,988485,560283,204722,1037660,616151,888659,545530,4500,1002515,299732,271061,203399,837,473445,10373,750365,748152,153597,725374,90215,301741,937458,747194,181806,243599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]