SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537741 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537741 [ RunTime:0.004777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119546,537374,559433,128217,57202,190191,201613,715788,338087,986296,386811,286944,453810,749897,228397,409821,206106,150893,841183,413161,561643,318181,673102,616607,677078,303770,414820,838454,187407,385533,860940,870360,911475,994632,880202,884441,37060,854929,339565,900393,918836,901805,117237,879417,468100,695386,67090,532038,256824,315361,524884,738559,165144,583739,407931,639211,616883,672501,279203,403818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]