SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506128 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506128 [ RunTime:0.002993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223309,464205,1045251,234741,817823,542934,29592,915008,488904,292846,239310,896999,551240,1035870,798297,908949,988361,723290,514959,971974,890792,295966,735294,49274,936436,747267,701489,564512,76612,461488,719247,53461,983001,792134,573701,723726,369766,505481,293298,316265,833531,363957,177641,1043032,758679,663886,516484,559757,346274,828488,61567,765368,740235,220652,196794,350098,629217,48323,905574,630648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]