SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504908 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504908 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301145,13547,846013,1025804,903019,172041,298354,492677,601153,808107,47073,406573,900971,640542,633069,60821,360910,846432,458804,880094,835557,992620,188073,617696,598598,213247,50018,698532,646693,475538,930858,209139,988415,958207,133150,397410,636991,232618,98187,549781,490561,59456,938317,1027918,670539,947913,879035,978581,10038,817544,467974,784789,767686,522656,766532,438544,767207,833708,595508,908930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]