SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003684 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003684 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136954,100643,273754,524221,700679,104926,682550,200328,623713,944279,37161,199704,156160,302127,834774,180308,79465,154767,412208,726910,781934,21513,708643,142954,666039,109429,605245,41071,942728,570398,1047585,420256,529076,631579,716033,360186,734288,764510,202708,901894,140556,928178,821354,198347,972591,959451,768770,34924,530163,263810,348808,741747,531849,106540,846816,180904,425266,804699,394518,226338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]