SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028978 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028978 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418596,816186,467797,190118,487912,511316,335883,234237,972937,228468,370150,851568,809746,301059,273855,41602,1004627,682655,119692,813383,58941,777337,211132,88327,980385,293384,419322,381365,730917,268589,9680,335325,468701,738275,324827,912897,718286,729033,752456,61834,885771,473848,893009,855288,150818,131767,339973,438087,179270,548529,434705,237518,541965,548243,1026476,331712,423941,1033740,318104,520483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]