SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522609 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522609 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433080,619843,952782,524881,812057,61545,1039457,300179,110791,595493,330494,107696,100373,926041,971597,116368,697140,946213,681194,5157,202787,963722,855494,339260,837749,834224,784357,433904,845432,897593,39324,50969,734834,846079,921088,670878,160604,431826,360812,485357,988522,533038,907276,51200,897771,970376,353495,129343,828211,833905,290891,170728,8826,911325,426491,607678,548862,572241,400966,435034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]