SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811311 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811311 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144218,983675,942153,713623,647205,285763,320490,365142,810166,424735,316715,315415,734286,537136,509819,495487,169085,685169,1020671,494589,420080,367977,929543,128332,412533,547048,296748,775440,744978,364090,154872,195660,170764,997125,1002669,885285,996390,407899,993417,303448,8202,378435,915009,883335,697800,620335,79963,287634,964991,396574,860692,693628,921192,131536,817592,289949,825347,456775,651728,145370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]