SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001850s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417094 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417094 [ RunTime:0.003591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41268,826270,1047820,159166,122827,880574,185858,29081,113116,1017278,732363,433177,10297,913613,735345,416419,869126,893233,1044209,950553,533321,149800,785751,177989,1047767,264418,579821,205000,997405,991294,602255,318828,974106,923266,563422,953897,701289,156838,634729,812197,885256,964017,170656,358006,169792,971227,364977,732472,241999,852313,354072,820304,617328,479774,898554,173474,277862,46452,844628,957743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003931s ]