SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445083 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445083 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127454,945790,823752,684513,657771,317706,588254,473587,379761,825595,422586,656565,618566,857680,919798,632377,626150,278511,354685,67071,201507,520314,561100,523683,612689,797735,585619,100476,683316,881358,969639,946841,874383,998882,538982,716134,338986,160450,661579,823256,588939,610008,675835,725160,791721,438426,588328,958369,550660,140886,79865,848713,756156,702676,279901,734662,121412,668210,918567,234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]