SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039085 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039085 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116703,347464,731754,243005,313459,913026,1012714,399987,117701,506493,868638,443929,188368,697508,361949,168075,906546,338101,689442,687441,270210,6042,254871,903885,850233,793194,794054,748772,628215,268233,993400,250865,254837,578186,713105,657167,680782,537503,92613,602365,675141,844149,55381,100945,860992,843703,613029,329182,446179,1016488,99179,5831,136605,677777,222184,361809,242418,8636,682154,727284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002196s ]