SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470971 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470971 [ RunTime:0.003444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579682,7373,388789,707835,312911,798676,314122,410976,726635,1029330,1026209,579776,774915,131306,195710,514254,215716,140784,308480,344520,677152,1005466,506064,703436,263441,47794,528539,935494,388585,294360,242996,106966,536292,88581,104566,812808,1045145,231613,823829,90146,873108,916980,281240,410596,291393,725340,430639,849008,762365,127538,765288,828813,162058,127945,862290,1001154,937591,788083,323599,382632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001614s ]