SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386791 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386791 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502600,381646,1000054,57006,792301,1018125,228690,99295,874360,909381,803406,170008,207255,204486,306082,912193,898476,379219,783498,518533,901255,612082,861007,143943,645155,69987,660912,309579,492057,895046,369077,405929,295670,944795,107509,109175,622784,226913,116074,880771,212555,635124,713548,273175,466267,194130,336635,252903,810778,927906,226381,187712,246794,440473,999462,920678,583822,960215,140407,828747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]