SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 84102 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 84102 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986226,108916,637021,109168,1007626,496587,177177,989751,628832,411982,227917,40073,76719,632758,935652,725000,710771,411251,911579,66223,214861,727331,258580,283162,155481,807237,863006,181800,505738,94308,419328,355977,1010212,952930,775026,406757,158839,431932,709943,155621,700358,1042527,152037,587999,472763,768602,494640,107105,354894,829638,123838,131820,1009021,937449,502365,54244,94400,396478,19665,197474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 84102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 84102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]