SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017191 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017191 [ RunTime:0.003689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761848,510937,338708,1006725,571250,952520,887186,239167,441644,296872,775436,844996,92176,869935,99031,964859,134568,43010,807692,528261,987158,453178,204848,348599,919964,342984,849667,468742,855605,394219,632898,1048790,302147,1045166,1044612,633067,574922,264762,784145,50783,605422,29687,36585,991292,279408,77523,155998,941715,1007111,507241,854221,224740,56415,10737,168335,552036,154425,46211,701024,637458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005470s ]