SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478316 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478316 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470770,288764,413196,306268,611321,446087,764473,453753,273884,445171,1013885,862146,777885,906152,314901,386842,218523,692000,716710,845090,37087,307536,300061,116053,731164,526290,594397,152222,569868,147562,156224,176992,979286,361419,582340,325399,719403,523937,289189,280805,115199,81307,802813,71683,314484,1040754,121195,293901,507720,244076,873201,357371,919999,219307,50928,229893,2344,112056,148434,411725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]