SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031516 LIMIT 1 [ RunTime:0.000587s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031516 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190268,780037,57640,973134,861079,450144,121578,1047785,818073,803809,929653,292500,935749,700656,90098,370187,47771,225288,407605,247079,1003686,96810,256393,43912,545440,637030,287560,223452,698016,603521,755835,149506,340546,821704,546532,520854,23672,215261,159435,487806,794932,689545,313274,785326,922318,994848,619207,89657,1030194,791037,277660,871070,927853,734079,899939,990751,87426,441740,314301,531123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]