SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475514 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475514 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922968,869179,103949,982444,503760,623706,224567,645857,806791,113725,39229,137356,495740,229841,541461,265544,884054,228393,890946,786551,882280,31824,133562,820487,120528,43995,418753,64085,610091,646389,597385,690655,486199,319107,1036029,210175,702284,469126,927466,525415,765781,582570,769044,943675,109247,746815,194522,732567,86227,739199,889204,24572,871383,1028746,319749,798434,276902,471340,411099,230382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]