SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017597 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017597 [ RunTime:0.002335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158817,359179,606974,886965,14452,1006552,914874,130062,653559,140495,1012820,222575,666071,769288,1044831,848787,817997,290425,558009,732252,669076,154770,43526,132606,99061,140332,109521,136526,123615,206605,311041,332146,237254,376842,730849,1048728,219485,762060,954272,646744,523719,102421,934822,883026,886126,897780,598245,896205,793565,408676,224334,1043872,557652,390736,828041,58507,418740,620346,654919,508463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]