SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109983 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109983 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480753,470005,140401,400329,363584,648879,180409,130038,1027559,996536,257890,189067,881302,740717,907793,924665,585362,992337,643381,407094,161351,550731,543958,28121,531105,268859,280784,806292,969335,898704,783690,1040203,155298,946835,463823,339465,647937,963278,132367,505220,960205,251042,426833,393529,705842,778217,576110,773662,150232,499323,311548,230904,909678,212272,356271,973883,921456,817566,296415,476810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]