SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017962 LIMIT 1 [ RunTime:0.001580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017962 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411634,769050,547786,484517,396837,211162,807482,939410,205396,898505,768785,602329,355293,896441,635693,321453,250237,571164,462895,683000,134980,239277,921138,935805,634623,441962,475731,770517,103540,912653,574295,794248,572768,417889,407812,406728,668353,1017021,776140,217821,586565,920468,101099,756405,207140,46559,596274,1001696,196888,319836,201896,390356,187598,338493,791512,616246,99506,945273,229419,104773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]