SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442678 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442678 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179257,546146,171936,578860,804175,91971,501343,480599,983410,159273,718699,392669,888801,46177,577243,94318,328682,391078,617035,209561,902998,338468,65436,716747,628174,961447,1045820,57900,674470,327425,799888,247991,100886,51487,81227,877175,471635,272629,604358,361375,274333,782438,1004789,258867,499001,633293,123278,891190,646096,20249,691313,496277,54759,662911,67192,730196,640827,921893,21498,233913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]