SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499751 LIMIT 1 [ RunTime:0.003572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499751 [ RunTime:0.005751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959173,795898,505667,56749,677230,175767,720017,57053,866714,271653,282402,620236,704369,504153,284207,429954,681468,419504,255669,823462,339412,395596,793984,799581,688888,635758,417577,601728,665469,675506,772427,59523,1002592,714304,125829,744298,442933,315363,667294,1026570,291408,433124,125214,726450,473565,704129,78563,724448,233250,739228,386592,945162,288228,602979,94010,1044803,699375,1047865,890525,404670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]