SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50441 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50441 [ RunTime:0.002617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458914,712460,191809,120849,868982,194002,793037,734693,208445,261569,540773,1038629,107939,480552,368296,523704,364466,898997,997729,519853,76651,138557,881731,890683,76466,707691,611168,221217,1408,30247,8203,65001,556720,1004276,126033,785239,641886,893180,656977,151747,215307,773417,302284,862580,196579,239005,987361,856062,502321,876138,982732,933461,496518,272840,848281,788484,529912,492065,26975,743942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]