SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469540 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469540 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92792,814693,753452,159420,582418,865065,52168,849417,623498,873116,694433,760567,315857,695760,334620,1006929,866544,442356,87076,905223,264463,689670,485839,1027210,146677,816879,320343,997857,263765,708886,165246,307066,120001,329074,324517,562612,496489,753696,805001,688079,103497,528480,941652,176852,171359,423201,942142,956147,37719,1047408,628993,163118,11906,622082,844910,153796,1033342,220569,169382,863725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]