SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409893 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409893 [ RunTime:0.001420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516428,729266,830598,204285,512263,830113,912792,309101,283794,774164,669915,874486,397313,1006918,769785,662489,202883,854747,306263,11,1034341,359088,314591,451398,313890,634370,147080,519477,105473,651729,743739,544059,14282,766380,115935,804234,636407,319222,900016,854096,275357,723402,813910,78367,801244,408775,802886,81635,561006,550896,640369,672107,897267,502985,991197,338828,660928,380151,528670,28784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]