SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467506 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467506 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429164,701592,328230,141920,304950,466221,794497,607599,285483,1046205,349777,350994,343155,385178,79731,265994,891143,477112,124673,447444,363063,623185,903066,247867,541286,806260,29772,538369,899709,491022,967017,222472,765286,200495,186847,270068,1013782,670136,792873,684303,308506,657083,211013,150447,921741,476943,51260,344663,800721,188280,760282,800438,996560,478735,616177,641784,384519,174032,280325,180630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]