SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450812 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450812 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449182,350827,323723,443445,354574,535952,127476,789536,439714,431097,254375,441273,705446,942471,69545,835560,283330,20147,525507,746907,103553,629071,572229,231270,917730,558268,476105,889011,597994,970046,23876,258964,990624,853016,241736,160880,882799,313144,1017451,10747,553678,195537,287514,578367,558139,685687,701869,790822,613961,171279,229153,466660,616364,174176,278329,38541,812528,282729,774085,22121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]