SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002002 LIMIT 1 [ RunTime:0.005035s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002002 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524246,920448,943870,688243,792558,216029,341568,28696,669563,82176,261088,1034745,403865,177551,208763,806421,358162,162502,622659,649747,17217,62136,976395,830797,172931,607493,324902,583626,347425,93876,441828,743055,992668,790731,128921,166475,240545,94705,974228,941451,148280,656933,512204,28661,277405,740255,786900,390096,1021038,990843,320513,683115,135545,328459,1011344,774475,573778,676642,640882,724928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]