SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416888 LIMIT 1 [ RunTime:0.000686s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416888 [ RunTime:0.003381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201343,795630,291468,512788,992317,797193,991501,177275,725081,985648,448861,965454,1016911,406812,381749,62644,70620,356698,634884,642526,437000,673033,574879,82600,270121,1033963,879840,433025,846641,393683,455403,797226,370451,997101,271257,942003,603309,387507,919391,880353,571444,300730,957171,314295,835571,972598,767630,912189,252051,584129,895669,576725,251765,787898,20751,956833,489261,41403,784672,510035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]