SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029749 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029749 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63034,805918,599367,982153,554515,711647,471162,279034,835903,582148,582754,998092,362387,536413,669961,799255,651673,130518,142908,360972,389138,195206,288320,723849,403239,912591,550857,981480,786558,118991,435138,108129,444613,217922,327965,707099,416456,912873,479282,110292,241435,251794,189405,35932,427629,176993,182347,630020,546018,587890,465881,260333,897875,1041955,677771,105008,995448,971555,780626,69190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]