SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462501 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462501 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15300,817804,296872,629490,765257,813163,82795,773219,183855,903100,305181,767885,212784,194879,419555,261071,841230,397881,566629,440045,521038,438973,120304,712238,743636,885436,180238,488600,498393,66805,437421,578721,26608,237574,915414,888845,317064,1040649,857414,921653,311712,230136,80298,719584,770415,472330,557201,916514,711046,319516,634594,274353,634410,619789,705740,31051,568889,1007273,802926,653999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]