SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547526 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547526 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193045,520075,724195,30040,358077,253273,280080,844787,313879,310660,959496,466213,81475,1030705,891907,254808,754432,388959,349628,461754,171521,1001474,322241,571907,594930,381766,422160,841560,751299,127086,62905,500098,688203,310898,891856,880612,7033,1037018,471489,737506,458692,497759,35269,855404,286218,686266,459386,583529,271705,982910,313176,755053,649305,600571,205532,874633,572895,933583,445181,1027111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]