SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805002 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805002 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672881,8257,815197,113941,422188,482784,85026,684040,583914,655895,232603,485861,878592,884994,714939,433485,439914,491499,1042029,310398,221160,27314,781349,704088,278432,628945,992272,158569,142032,829475,710946,147835,808402,993940,410812,877336,756065,68603,887366,427473,637750,692590,369701,820304,778388,413129,230815,97758,1016190,939276,176780,410019,888541,1025385,340374,454521,25791,358638,278382,344059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]