SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17603 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17603 [ RunTime:0.003180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402021,503287,72243,31459,642399,1047095,472838,566973,797283,587403,519421,356446,584504,680120,297846,382880,824327,465883,320327,216890,390544,131512,712525,244386,88169,133259,515021,53378,768091,437826,827936,799900,828575,503116,656274,34444,964458,580881,888565,1008115,159115,454287,273674,654143,884580,652162,356715,735060,932613,227556,345854,608238,1015642,535115,868555,148443,534428,308269,175036,143034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]