SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483940 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483940 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930874,176182,291377,73626,381394,200358,678630,898597,927023,897924,585727,401520,793702,1018116,438340,880392,721384,205202,944707,627363,929953,562449,125427,1012885,221040,482535,1031740,645739,244688,926365,292992,558999,298775,260525,882503,774142,953764,507030,542742,288810,1048203,88399,1023065,32161,1022005,988195,996156,815082,824192,346520,990886,912246,81144,134748,430407,343177,639556,1025057,322635,964914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]