SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397674 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397674 [ RunTime:0.005563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367968,332611,991552,872113,154168,1039489,1011909,311941,183320,435228,400632,1013265,38577,329156,1007002,755466,450219,676611,558873,259013,998368,755424,218675,534548,321451,809564,594009,297095,766439,493713,688750,192025,164573,194115,530664,206519,446183,416548,525647,547629,940785,304143,332661,100798,721902,623213,437415,222098,574682,723116,811777,833670,657810,698680,110010,185097,968289,790588,217751,584046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]