SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042040 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042040 [ RunTime:0.003430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6061,200533,818466,188015,922948,27677,639101,44003,409189,993489,861320,223577,589298,662311,581259,717925,342423,402597,221240,208486,103400,573600,26254,558325,812714,74509,573357,324557,705487,1034854,63557,808146,548396,212761,764307,1037271,451758,748781,123128,569001,1016286,157478,131324,350149,211347,268934,996615,205519,57555,158183,409634,88940,571898,959286,154186,966711,669963,473194,892012,193306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]