SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478891 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478891 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338695,174807,668750,529828,173334,305774,53061,398451,435590,452383,248459,679346,240192,496251,171917,651230,548311,499972,868756,278203,775461,340931,390950,599881,94425,103444,392602,785180,505596,904392,196987,800674,331691,166351,164353,326918,704470,1043254,6515,126329,961992,606829,599286,999846,788067,567880,570085,782817,79976,973650,780858,564941,87693,824303,679672,546546,19204,991584,122324,848407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]