SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404058 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404058 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583779,191476,387961,504271,951417,732516,1004402,770604,792657,935049,340452,442413,179180,407251,536260,125550,327484,19870,114496,989844,393994,424434,64906,855941,702977,547525,14838,816970,839842,558523,8012,464131,207572,1043757,352199,496104,746284,1032663,934713,884745,196129,280193,357637,554058,680760,588875,875562,433991,309463,400505,905436,161678,895743,757073,830822,319906,1020649,613308,567130,963641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]