SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40019 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40019 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401419,531936,999594,1016429,576988,801709,405419,899061,666538,261243,93598,356339,53788,134786,29077,266647,1042061,221569,336862,541914,501018,657126,555055,980682,890864,161755,864801,101791,927363,481195,771806,6719,710553,3050,962336,284265,74993,760147,38067,234178,364462,458898,598207,988678,86515,394302,466958,942658,189636,232051,857495,701481,501761,805185,470664,11886,554524,958795,551991,644637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]