SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124985 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124985 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267311,733126,988945,668054,940700,589565,779196,704043,144001,350060,1048889,105537,27460,906786,794023,865662,973850,810655,117937,154511,812462,428633,173778,722271,226436,595948,799388,192985,38071,518409,747912,351533,28872,379885,743,868058,388087,406515,497655,100049,940837,381556,217902,56592,593594,762963,88236,148838,896804,87532,685904,110872,967977,67984,385734,311925,331656,288324,282841,207638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002927s ]