SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419919 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419919 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804198,146259,205786,118417,241849,1003006,435261,147157,812131,489540,32668,761419,176499,633406,182991,704220,1027123,416793,287562,415319,422768,741027,87632,333011,12001,304883,844802,379426,920529,62808,535943,9795,795808,270264,616934,89346,250003,286550,715454,843977,871208,325683,456570,590004,873427,95338,429766,195891,507348,887948,236276,542948,174043,162046,713692,561543,544316,75502,1025963,792409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]