SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491422 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491422 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545845,523784,286235,50189,1043783,952933,417685,148220,340181,456769,126829,847220,473923,583487,135315,477978,1012495,700070,372234,980135,59046,1015756,814801,1033440,774455,292708,1005167,466270,306048,30512,482629,316258,330378,971074,471280,371065,1008135,223403,919066,512592,805726,828439,20248,608624,913634,335030,208718,911996,998432,123008,672316,272506,278392,660294,473359,666289,446170,595229,643228,954993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]